import openpyxl as op

#目标excel路径
file=''
wb=op.load_workbook(file)
ws=wb['1月']
months=[]

for i in range(2,13,1):
    months.append(str(i)+'月')
for i in range(len(months)):
    wb.create_sheet(months[i])
 
for k in months:
    ws1=wb[k]
    for i,row in enumerate(ws.iter_rows()):
        for j,cell in enumerate(row):
            ws1.cell(row=i+1, column=j+1, value=cell.value)
wb.save(file)